---
displayed_sidebar: "English"
---

# SHOW ROUTINE LOAD TASK

import RoutineLoadPrivNote from '../../../assets/commonMarkdown/RoutineLoadPrivNote.md'

## Description

Shows the execution information of load tasks within a Routine Load job.

:::note

- <RoutineLoadPrivNote />

- For the relationship between a Routine Load job and the load tasks in it, see [Load data using Routine Load](../../../loading/RoutineLoad.md#basic-concepts)
:::

## Syntax

```SQL
SHOW ROUTINE LOAD TASK
[  FROM <db_name>]
[  WHERE JobName = <job_name> ]
```

:::note

You can add the `\G` option to the statement (such as `SHOW ROUTINE LOAD TASK WHERE JobName = <job_name>\G`) to vertically display the return result rather than in the usual horizontal table format.

:::

## Parameters

| **Parameter** | **Required** | **Description**                                             |
| ------------- | ------------ | ----------------------------------------------------------- |
| db_name       | No           | The name of the database to which the Routine Load job belongs. |
| JobName       | No           | The name of the Routine Load job.                               |

## Output

| **Parameter**        | **Description**                                              |
| -------------------- | ------------------------------------------------------------ |
| TaskId               | The globally unique ID of the load task, automatically generated by StarRocks. |
| TxnId                | The ID of the transaction to which the load task belongs.        |
| TxnStatus            | The status of the transaction to which the load task belongs. `UNKNOWN` indicates that the transaction is not started yet, possibly because the load task is not dispatched or executed. |
| JobId                | The ID of the load job.                                          |
| CreateTime           | The date and time when the load task was created.            |
| LastScheduledTime    | The date and time when the load task was last scheduled.     |
| ExecuteStartTime     | The date and time when the load task was executed.           |
| Timeout              | The timeout period for the load task, controlled by the FE parameter [`routine_load_task_timeout_second`](../../../administration/FE_configuration.md#routine_load_task_timeout_second) and the `task_timeout_second` parameter in [job_properties](./CREATE_ROUTINE_LOAD.md#job_properties) for the Routine Load job. |
| BeId                 | The ID of the BE that executes the load task.                    |
| DataSourceProperties | The load task's progress (measured in the offset) of consuming messages in partitions of the topic. |
| Message              | The information returned for the load task, including task error information. |

## Examples

View all load tasks in the Routine Load job `example_tbl_ordertest`.

```SQL
MySQL [example_db]> SHOW ROUTINE LOAD TASK WHERE JobName = "example_tbl_ordertest";  
+--------------------------------------+-------+-----------+-------+---------------------+---------------------+------------------+---------+------+------------------------------------+-----------------------------------------------------------------------------+
| TaskId                               | TxnId | TxnStatus | JobId | CreateTime          | LastScheduledTime   | ExecuteStartTime | Timeout | BeId | DataSourceProperties               | Message                                                                     |
+--------------------------------------+-------+-----------+-------+---------------------+---------------------+------------------+---------+------+------------------------------------+-----------------------------------------------------------------------------+
| abde6998-c19a-43d6-b48c-6ca7e14144a3 | -1    | UNKNOWN   | 10208 | 2023-12-22 12:46:10 | 2023-12-22 12:47:00 | NULL             | 60      | -1   | Progress:{"0":6},LatestOffset:null | there is no new data in kafka/pulsar, wait for 10 seconds to schedule again |
+--------------------------------------+-------+-----------+-------+---------------------+---------------------+------------------+---------+------+------------------------------------+-----------------------------------------------------------------------------+
1 row in set (0.00 sec)
```
